Add more flexibility in designing the layout of a Pivot Table report
> Create Pivot Table and get the data and grouping needed
> Change conditional formatting to high-light measures,
On the Options tab, in the Tools group, click OLAP tools, and then click Convert to Formulas.
> Do additional columsn and changed formula if needed
http://office.microsoft.com/en-us/excel-help/convert-pivottable-cells-to-worksheet-formulas-HA010096303.aspx
> Create Pivot Table and get the data and grouping needed
> Change conditional formatting to high-light measures,
On the Options tab, in the Tools group, click OLAP tools, and then click Convert to Formulas.
> Do additional columsn and changed formula if needed
http://office.microsoft.com/en-us/excel-help/convert-pivottable-cells-to-worksheet-formulas-HA010096303.aspx